package com.micronote.provider.entity;

import java.util.HashMap;

import com.micronote.provider.DatabaseHelper;

public class Note {
	
	final static public String GUID = "guid";
	final static public String NOTEBOOK_GUID = "notebook_guid";
	final static public String TITLE = "title";
	final static public String CONTENT = "content";
	final static public String CONTENT_LENGTH = "content_length";
	final static public String CREATE_TIME = "create_time";
	final static public String UPDATE_TIME = "update_time";
	final static public String DELETE_TIME = "delete_time";
	final static public String DIRTY = "dirty";
	final static public String CONTENT_TYPE = "content_type";
	final static public String CONTENT_LOCATION = "content_location";
	
	

	static public String create()
	{
		HashMap<String, String> columns = new HashMap<String, String>();
		
		columns.put("guid", "VARCHAR(36) PRIMARY KEY");
		columns.put("notebook_guid", "VARCHAR(36)");
		columns.put("title", "VARCHAR(255)");
		columns.put("content", "TEXT");
		columns.put("content_length", "INTEGER");
		columns.put("created_time", "INTEGER NOT NULL");
		columns.put("updated_time", "INTEGER");
		columns.put("deleted_time", "INTEGER");
		columns.put("dirty", "INTEGER");
		columns.put("content_type", "VARCHAR(255)");
		columns.put("content_location", "VARCHAR(255)");
		columns.put("latitude", "REAL");
		columns.put("longitude", "REAL");
		columns.put("altitude", "REAL");
		columns.put("weather", "VARCHAR(255)");
		columns.put("mood", "VARCHAR(50)");
		columns.put("author", "VARCHAR(255)");
		

		return DatabaseHelper.createTable("note", columns);
	}
	
	
	public void setGuid(String guid)
	{
		
	}
	
	public void setTitle(String title)
	{
		
	}
	
	public void setUpdateTime(long time)
	{
		
	}
}
